Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_PROXY_ARCHIVELOG_SUMMARY

`RC_PROXY_ARCHIVELOG_SUMMARY` contains a summary of proxy copy backups of archived redo logs.

This view is primarily intended to be used internally by Enterprise Manager.

Column | Datatype | Description
--- | --- | ---
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`DB_KEY` | `NUMBER` | The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
`NUM_FILES_BACKED` | `NUMBER` | Total number of archived redo log files backed up.
`NUM_DISTINCT_FILES_BACKED` | `NUMBER` | Number of distinct archived redo log files backed up.
`MIN_FIRST_CHANGE#` | `NUMBER` | Minimum value for the first SCN of any redo log file in this summary.
`MAX_NEXT_CHANGE#` | `NUMBER` | Maximum value for the "next change#" SCN of any redo log file in this summary.
`MIN_FIRST_TIME` | `DATE` | Minimum value for the time of the first change in any redo log. Along with MAX_NEXT_TIME, forms the redo range.
`MAX_NEXT_TIME` | `DATE` | Maximum value for the time of the next change after any redo logs in this session.
`OUTPUT_BYTES` | `NUMBER` | Sum of sizes of all output pieces generated by this job.
`OUTPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example nM, nG, nT, nP.